home *** CD-ROM | disk | FTP | other *** search
/ InterCD 2001 January / january_2001.iso / intercd / root / ^4Developers / VB / visbasdb / VBDB / VBDB Code / VB6 Code / Class 3 / QuickExample1.frm (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1999-08-28  |  4.1 KB  |  139 lines
  1. VERSION 5.00
  2. Begin VB.Form frmTitles 
  3.    BorderStyle     =   1  'Fixed Single
  4.    Caption         =   "Titles Database"
  5.    ClientHeight    =   3195
  6.    ClientLeft      =   45
  7.    ClientTop       =   330
  8.    ClientWidth     =   5400
  9.    LinkTopic       =   "Form1"
  10.    MaxButton       =   0   'False
  11.    MinButton       =   0   'False
  12.    ScaleHeight     =   3195
  13.    ScaleWidth      =   5400
  14.    StartUpPosition =   3  'Windows Default
  15.    Begin VB.CommandButton cmdNext 
  16.       Caption         =   "&Next"
  17.       Height          =   495
  18.       Left            =   3000
  19.       TabIndex        =   9
  20.       Top             =   2640
  21.       Width           =   1215
  22.    End
  23.    Begin VB.CommandButton cmdPrevious 
  24.       Caption         =   "&Previous"
  25.       Height          =   495
  26.       Left            =   1440
  27.       TabIndex        =   8
  28.       Top             =   2640
  29.       Width           =   1215
  30.    End
  31.    Begin VB.Data datTitles 
  32.       Caption         =   "Titles"
  33.       Connect         =   "Access"
  34.       DatabaseName    =   "c:\VBDB\Working\Biblio.mdb"
  35.       DefaultCursorType=   0  'DefaultCursor
  36.       DefaultType     =   2  'UseODBC
  37.       Exclusive       =   0   'False
  38.       Height          =   300
  39.       Left            =   1200
  40.       Options         =   0
  41.       ReadOnly        =   -1  'True
  42.       RecordsetType   =   1  'Dynaset
  43.       RecordSource    =   "Titles"
  44.       Top             =   2640
  45.       Visible         =   0   'False
  46.       Width           =   3060
  47.    End
  48.    Begin VB.TextBox txtPubID 
  49.       DataField       =   "PubID"
  50.       DataSource      =   "datTitles"
  51.       Height          =   495
  52.       Left            =   1440
  53.       Locked          =   -1  'True
  54.       TabIndex        =   5
  55.       Top             =   1920
  56.       Width           =   3615
  57.    End
  58.    Begin VB.TextBox txtISBN 
  59.       DataField       =   "ISBN"
  60.       DataSource      =   "datTitles"
  61.       Height          =   495
  62.       Left            =   1440
  63.       Locked          =   -1  'True
  64.       TabIndex        =   4
  65.       Top             =   1320
  66.       Width           =   3615
  67.    End
  68.    Begin VB.TextBox txtYearPublished 
  69.       DataField       =   "Year Published"
  70.       DataSource      =   "datTitles"
  71.       Height          =   495
  72.       Left            =   1440
  73.       Locked          =   -1  'True
  74.       TabIndex        =   3
  75.       Top             =   720
  76.       Width           =   3615
  77.    End
  78.    Begin VB.TextBox txtTitle 
  79.       DataField       =   "Title"
  80.       DataSource      =   "datTitles"
  81.       Height          =   495
  82.       Left            =   1440
  83.       Locked          =   -1  'True
  84.       TabIndex        =   1
  85.       Top             =   120
  86.       Width           =   3615
  87.    End
  88.    Begin VB.Label Label4 
  89.       Caption         =   "Publisher ID"
  90.       Height          =   495
  91.       Left            =   120
  92.       TabIndex        =   7
  93.       Top             =   2040
  94.       Width           =   1215
  95.    End
  96.    Begin VB.Label Label3 
  97.       Caption         =   "ISBN"
  98.       DataField       =   "IS"
  99.       Height          =   495
  100.       Left            =   120
  101.       TabIndex        =   6
  102.       Top             =   1440
  103.       Width           =   1215
  104.    End
  105.    Begin VB.Label Label2 
  106.       Caption         =   "Year Published"
  107.       Height          =   495
  108.       Left            =   120
  109.       TabIndex        =   2
  110.       Top             =   840
  111.       Width           =   1215
  112.    End
  113.    Begin VB.Label Label1 
  114.       Caption         =   "Title"
  115.       Height          =   495
  116.       Left            =   120
  117.       TabIndex        =   0
  118.       Top             =   240
  119.       Width           =   1215
  120.    End
  121. Attribute VB_Name = "frmTitles"
  122. Attribute VB_GlobalNameSpace = False
  123. Attribute VB_Creatable = False
  124. Attribute VB_PredeclaredId = True
  125. Attribute VB_Exposed = False
  126. Option Explicit
  127. Private Sub cmdNext_Click()
  128. datTitles.Recordset.MoveNext
  129. If datTitles.Recordset.EOF Then
  130.   datTitles.Recordset.MoveLast
  131. End If
  132. End Sub
  133. Private Sub cmdPrevious_Click()
  134. datTitles.Recordset.MovePrevious
  135. If datTitles.Recordset.BOF Then
  136.   datTitles.Recordset.MoveFirst
  137. End If
  138. End Sub
  139.